sql="update data set h='0',r='" &LHB_GongHao &"',date='" &Now() &"' where id = "+id

来源：百度知道编辑：UC知道时间：2024/05/09 11:42:28

这个语句可以更新一个表里面的三个值吗？好像不对啊，帮忙看看挖
<%
id=Request("ID")

If Session("LHB_GongHao") <> "" Then
LHB_GongHao=Session("LHB_GongHao")

dim sql

sql="update data set h='0',r='" &LHB_GongHao &" ',date='" &Now () & "' id = "+id

'Response.write sql
'Response.End()
db.execute(sql)
Response.Redirect "index.asp"
End if
%>
帮忙看看这样为什么不对

改成这样试试,另如果date字段为日期时间型的,单引号就别用了:
sql="update data set h='0',r='" &LHB_GongHao &" ',date='" &Now () & "' where id = "&id

sql= "更新数据集h='0'， r='" &LHB_GongHao &” ‘date=’” &Now () & "’ id = “+id 的地方

" sql=sql & sqlstr(NewsTitle) & " sql=sql & " order by m_id DESC" sql="select * from user" sql = sql&"content like '%"&keywordarray(0)&"%'"中%什么意思 sql = sql + request("txtxh") + ","无法添加到数据库 sql="select * from问题 sql="select * from sg where 我的卡巴斯基开机就说"C:/Program Files/common files/UPDAT/update.exe"这个是病毒,是怎么回事啊? sql="select * from……" sql = "Select top 5 * from news"